UPDATE renault_2013_data SET MODEL = 'Captur' WHERE MODEL = 'CAPTUR'
UPDATE renault_2013_data SET MODEL = 'Captur' WHERE MODEL = 'Captur'
UPDATE renault_2013_data SET MODEL = 'Clio Sport Tourer' WHERE MODEL = 'CLIO SPORT TOURER '
UPDATE renault_2013_data SET MODEL = 'Fluence' WHERE MODEL = 'FLUENCE'
UPDATE renault_2013_data SET MODEL = 'Grand Scenic' WHERE MODEL = 'GRAND SCENIC'
UPDATE renault_2013_data SET MODEL = 'Latitude' WHERE MODEL = 'LATITUDE'
UPDATE renault_2013_data SET MODEL = 'Latitude' WHERE MODEL = 'Latitude'
UPDATE renault_2013_data SET MODEL = 'Megane HB' WHERE MODEL = 'MEGANE HB '
UPDATE renault_2013_data SET MODEL = 'Megane HB' WHERE MODEL = 'Megane HB'
UPDATE renault_2013_data SET MODEL = 'Megane III Coupe' WHERE MODEL = 'MEGANE III COUPE'
UPDATE renault_2013_data SET MODEL = 'Megane III HB' WHERE MODEL = 'MEGANE III HB'
UPDATE renault_2013_data SET MODEL = 'Megane Sport Tourer' WHERE MODEL = 'MEGANE SPORT TOURER'
UPDATE renault_2013_data SET MODEL = 'Megane Sport Tourer' WHERE MODEL = 'Megane Sport Tourer'
UPDATE renault_2013_data SET MODEL = 'Scenic' WHERE MODEL = 'SCENIC'
UPDATE renault_2013_data SET MODEL = 'Yeni Clio' WHERE MODEL = 'YENI CLIO'
UPDATE renault_2013_data SET MODEL = 'Yeni Clio' WHERE MODEL = 'Yeni Clio'
UPDATE renault_2013_data SET MODEL = 'Yeni Clio Sport Tourer' WHERE MODEL = 'Yeni Clio Sport Tourer'
UPDATE renault_2013_data SET MODEL = 'Yeni Fluence' WHERE MODEL = 'Yeni Fluence'
UPDATE renault_2013_data SET MODEL = 'Yeni Latitude' WHERE MODEL = 'Yeni Latitude'
UPDATE renault_2013_data SET MODEL = 'Yeni Master' WHERE MODEL = 'YENI MASTER'
UPDATE renault_2013_data SET MODEL = 'Yeni Megane HB' WHERE MODEL = 'Yeni Megane HB'
UPDATE renault_2013_data SET MODEL = 'Yeni Megane Sport Tourer' WHERE MODEL = 'Yeni Megane Sport Tourer'
UPDATE renault_2013_data SET MODEL = 'Yeni Scenic' WHERE MODEL = 'Yeni Scenic'
UPDATE renault_2013_data SET MODEL = 'Yeni Symbol' WHERE MODEL = 'YENI SYMBOL'
UPDATE renault_2013_data SET MODEL = 'Yeni Symbol' WHERE MODEL = 'Yeni Symbol'
UPDATE renault_2013_data SET MODEL = 'Symbol' WHERE MODEL = 'SYMBOL'
UPDATE renault_2013_data SET MODEL = 'Clio Grand Tourer' WHERE MODEL = 'CLIO GRAND TOUR'




UPDATE renault_2013_data SET MODEL = 'Master' WHERE MODEL = 'MASTER'
UPDATE renault_2013_data SET MODEL = 'Master Kamyonet' WHERE MODEL = 'Master Kamyonet'
UPDATE renault_2013_data SET MODEL = 'Master Panelvan' WHERE MODEL = 'Master Panelvan'
UPDATE renault_2013_data SET MODEL = 'Trafic' WHERE MODEL = 'TRAFIC'
UPDATE renault_2013_data SET MODEL = 'Trafic' WHERE MODEL = 'Trafic'
UPDATE renault_2013_data SET MODEL = 'Yeni Kangoo Express' WHERE MODEL = 'YENI KANGOO EXPRESS'
UPDATE renault_2013_data SET MODEL = 'Yeni Kangoo Express' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE renault_2013_data SET MODEL = 'Yeni Kangoo Multix' WHERE MODEL = 'YENI KANGOO MULTIX'
UPDATE renault_2013_data SET MODEL = 'Yeni Kangoo Multix' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE renault_2013_data SET MODEL = 'Yeni Master' WHERE MODEL = 'YENI MASTER'





UPDATE renault_2013_data SET MODEL = 'Duster' WHERE MODEL = 'DUSTER'
UPDATE renault_2013_data SET MODEL = 'Duster' WHERE MODEL = 'Duster'
UPDATE renault_2013_data SET MODEL = 'Lodgy' WHERE MODEL = 'LODGY'
UPDATE renault_2013_data SET MODEL = 'Lodgy' WHERE MODEL = 'Lodgy'
UPDATE renault_2013_data SET MODEL = 'Logan MCV' WHERE MODEL = 'LOGAN MCV'
UPDATE renault_2013_data SET MODEL = 'Sandero' WHERE MODEL = 'SANDERO'
UPDATE renault_2013_data SET MODEL = 'Yeni Duster' WHERE MODEL = 'Yeni Duster'
UPDATE renault_2013_data SET MODEL = 'Yeni Logan MCV' WHERE MODEL = 'Yeni Logan MCV'
UPDATE renault_2013_data SET MODEL = 'Yeni Sandero' WHERE MODEL = 'Yeni Sandero'


UPDATE renault_2013_data SET MODEL = 'Dokker Combi' WHERE MODEL = 'DOKKER CAMLI'
UPDATE renault_2013_data SET MODEL = 'Dokker Combi' WHERE MODEL = 'Dokker Combi'
UPDATE renault_2013_data SET MODEL = 'Dokker Van' WHERE MODEL = 'DOKKER VAN'
UPDATE renault_2013_data SET MODEL = 'Dokker Van' WHERE MODEL = 'Dokker Van'




UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Captur'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Captur'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Clio Sport Tourer'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Fluence'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Grand Scenic'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Latitude'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Latitude'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane HB'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane HB'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane III Coupe'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane III HB'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane Sport Tourer'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane Sport Tourer'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Scenic'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio Sport Tourer'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Fluence'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Latitude'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Master'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Megane HB'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Megane Sport Tourer'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Scenic'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Symbol'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Symbol'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Symbol'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Clio Grand Tourer'




UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master Kamyonet'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master Panelvan'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Trafic'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Trafic'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE renault_2013_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Master'





UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Duster'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Duster'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Lodgy'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Lodgy'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Logan MCV'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Sandero'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Duster'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Logan MCV'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Sandero'


UPDATE renault_2013_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Combi'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Combi'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Van'
UPDATE renault_2013_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Van'



-- SELECT MODEL, MODELGRUP from renault_2013_data GROUP BY MODEL, MODELGRUP ORDER BY MODELGRUP, MODEL ASC


UPDATE satis_surec_data SET MODEL = 'Captur' WHERE MODEL = 'CAPTUR'
UPDATE satis_surec_data SET MODEL = 'Captur' WHERE MODEL = 'Captur'
UPDATE satis_surec_data SET MODEL = 'Clio Sport Tourer' WHERE MODEL = 'CLIO SPORT TOURER '
UPDATE satis_surec_data SET MODEL = 'Fluence' WHERE MODEL = 'FLUENCE'
UPDATE satis_surec_data SET MODEL = 'Grand Scenic' WHERE MODEL = 'GRAND SCENIC'
UPDATE satis_surec_data SET MODEL = 'Latitude' WHERE MODEL = 'LATITUDE'
UPDATE satis_surec_data SET MODEL = 'Latitude' WHERE MODEL = 'Latitude'
UPDATE satis_surec_data SET MODEL = 'Megane HB' WHERE MODEL = 'MEGANE HB '
UPDATE satis_surec_data SET MODEL = 'Megane HB' WHERE MODEL = 'Megane HB'
UPDATE satis_surec_data SET MODEL = 'Megane III Coupe' WHERE MODEL = 'MEGANE III COUPE'
UPDATE satis_surec_data SET MODEL = 'Megane III HB' WHERE MODEL = 'MEGANE III HB'
UPDATE satis_surec_data SET MODEL = 'Megane Sport Tourer' WHERE MODEL = 'MEGANE SPORT TOURER'
UPDATE satis_surec_data SET MODEL = 'Megane Sport Tourer' WHERE MODEL = 'Megane Sport Tourer'
UPDATE satis_surec_data SET MODEL = 'Scenic' WHERE MODEL = 'SCENIC'
UPDATE satis_surec_data SET MODEL = 'Yeni Clio' WHERE MODEL = 'YENI CLIO'
UPDATE satis_surec_data SET MODEL = 'Yeni Clio' WHERE MODEL = 'Yeni Clio'
UPDATE satis_surec_data SET MODEL = 'Yeni Clio Sport Tourer' WHERE MODEL = 'Yeni Clio Sport Tourer'
UPDATE satis_surec_data SET MODEL = 'Yeni Fluence' WHERE MODEL = 'Yeni Fluence'
UPDATE satis_surec_data SET MODEL = 'Yeni Latitude' WHERE MODEL = 'Yeni Latitude'
UPDATE satis_surec_data SET MODEL = 'Yeni Master' WHERE MODEL = 'YENI MASTER'
UPDATE satis_surec_data SET MODEL = 'Yeni Megane HB' WHERE MODEL = 'Yeni Megane HB'
UPDATE satis_surec_data SET MODEL = 'Yeni Megane Sport Tourer' WHERE MODEL = 'Yeni Megane Sport Tourer'
UPDATE satis_surec_data SET MODEL = 'Yeni Scenic' WHERE MODEL = 'Yeni Scenic'
UPDATE satis_surec_data SET MODEL = 'Yeni Symbol' WHERE MODEL = 'YENI SYMBOL'
UPDATE satis_surec_data SET MODEL = 'Yeni Symbol' WHERE MODEL = 'Yeni Symbol'
UPDATE satis_surec_data SET MODEL = 'Symbol' WHERE MODEL = 'SYMBOL'
UPDATE satis_surec_data SET MODEL = 'Clio Grand Tourer' WHERE MODEL = 'CLIO GRAND TOUR'




UPDATE satis_surec_data SET MODEL = 'Master' WHERE MODEL = 'MASTER'
UPDATE satis_surec_data SET MODEL = 'Master Kamyonet' WHERE MODEL = 'Master Kamyonet'
UPDATE satis_surec_data SET MODEL = 'Master Panelvan' WHERE MODEL = 'Master Panelvan'
UPDATE satis_surec_data SET MODEL = 'Trafic' WHERE MODEL = 'TRAFIC'
UPDATE satis_surec_data SET MODEL = 'Trafic' WHERE MODEL = 'Trafic'
UPDATE satis_surec_data SET MODEL = 'Yeni Kangoo Express' WHERE MODEL = 'YENI KANGOO EXPRESS'
UPDATE satis_surec_data SET MODEL = 'Yeni Kangoo Express' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE satis_surec_data SET MODEL = 'Yeni Kangoo Multix' WHERE MODEL = 'YENI KANGOO MULTIX'
UPDATE satis_surec_data SET MODEL = 'Yeni Kangoo Multix' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE satis_surec_data SET MODEL = 'Yeni Master' WHERE MODEL = 'YENI MASTER'





UPDATE satis_surec_data SET MODEL = 'Duster' WHERE MODEL = 'DUSTER'
UPDATE satis_surec_data SET MODEL = 'Duster' WHERE MODEL = 'Duster'
UPDATE satis_surec_data SET MODEL = 'Lodgy' WHERE MODEL = 'LODGY'
UPDATE satis_surec_data SET MODEL = 'Lodgy' WHERE MODEL = 'Lodgy'
UPDATE satis_surec_data SET MODEL = 'Logan MCV' WHERE MODEL = 'LOGAN MCV'
UPDATE satis_surec_data SET MODEL = 'Sandero' WHERE MODEL = 'SANDERO'
UPDATE satis_surec_data SET MODEL = 'Yeni Duster' WHERE MODEL = 'Yeni Duster'
UPDATE satis_surec_data SET MODEL = 'Yeni Logan MCV' WHERE MODEL = 'Yeni Logan MCV'
UPDATE satis_surec_data SET MODEL = 'Yeni Sandero' WHERE MODEL = 'Yeni Sandero'


UPDATE satis_surec_data SET MODEL = 'Dokker Combi' WHERE MODEL = 'DOKKER CAMLI'
UPDATE satis_surec_data SET MODEL = 'Dokker Combi' WHERE MODEL = 'Dokker Combi'
UPDATE satis_surec_data SET MODEL = 'Dokker Van' WHERE MODEL = 'DOKKER VAN'
UPDATE satis_surec_data SET MODEL = 'Dokker Van' WHERE MODEL = 'Dokker Van'




UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Captur'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Captur'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Clio Sport Tourer'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Fluence'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Grand Scenic'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Latitude'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Latitude'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane HB'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane HB'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane III Coupe'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane III HB'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane Sport Tourer'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Megane Sport Tourer'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Scenic'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Clio Sport Tourer'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Fluence'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Latitude'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Master'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Megane HB'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Megane Sport Tourer'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Scenic'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Symbol'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Yeni Symbol'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Symbol'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Binek' WHERE MODEL = 'Clio Grand Tourer'




UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master Kamyonet'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Master Panelvan'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Trafic'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Trafic'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Express'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Kangoo Multix'
UPDATE satis_surec_data SET MODELGRUP = 'Renault Ticari' WHERE MODEL = 'Yeni Master'





UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Duster'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Duster'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Lodgy'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Lodgy'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Logan MCV'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Sandero'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Duster'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Logan MCV'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Binek' WHERE MODEL = 'Yeni Sandero'


UPDATE satis_surec_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Combi'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Combi'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Van'
UPDATE satis_surec_data SET MODELGRUP = 'Dacia Ticari' WHERE MODEL = 'Dokker Van'

-- SELECT MODEL, MODELGRUP from satis_surec_data GROUP BY MODEL, MODELGRUP ORDER BY MODELGRUP, MODEL ASC

UPDATE satis_surec_data SET MODEL = 'Yeni Clio' WHERE MODEL = 'YEN? CLIO'
UPDATE satis_surec_data SET MODEL = 'Yeni Symbol' WHERE MODEL = 'YEN? SYMBOL'

GO

/* User Authorization Level */

ALTER TABLE [user] ADD AuthLevel VARCHAR(16)
GO

UPDATE [user] SET AuthLevel = 'dealer' WHERE dealercode is not NULL
GO

UPDATE [user] SET dealercode = NULL WHERE LEN(dealercode) <> 5
UPDATE [user] SET AuthLevel = NULL WHERE dealercode IS NULL
-- SELECT * FROM [user] WHERE AuthLevel IS NOT NULL

UPDATE [user] SET AuthLevel = 'coordinator' WHERE [user_name] IN
(
	'alptekin.genc',
	'kelleci',
	'IKARAYAZI',
	'CAPANOGLU',
	'apak',
	
	'arda.uzman',
	'MOCUK',
	'mehmet.ozencakir',
	'EREN',
	'ERSOY',
	'KARAYAZI',
	'DEMIR',
	'OZKIRAZ',
	'ersoy.yilmaz',
	'cenk.kinay',
	
	'OZTOSUN',
	'KOYUNOGLU',
	'IKARAYAZI',
	
	'OZTOSUN',	
	'DEMIRALP',
	'OZKOC',
	'GUNGOR',
	'ERENOGLU'
)
GO

UPDATE [user] SET AuthLevel = 'hq' WHERE AuthLevel IS NULL

